using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VKADBZU
    {
        public DataRow Convert2KADBZU(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryKADBZU(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["KADBMANDANT"] = " ".PadRight(2 ); 
         dwReturn["KADBDAT"] = " ".PadRight(8 ); 
         dwReturn["KADBAENZL"] = " ".PadRight(0 ); 
         dwReturn["KADBAENB"] = " ".PadRight(8 ); 
         dwReturn["KADBAEND"] = " ".PadRight(0 ); 
         dwReturn["KADBNEUB"] = " ".PadRight(8 ); 
         dwReturn["KADBNEUD"] = " ".PadRight(0 ); 
         dwReturn["KADBHWZS"] = " ".PadRight(2 ); 
         dwReturn["KADBHWT"] = " ".PadRight(16 ); 
         dwReturn["KADBMKZS"] = " ".PadRight(2 ); 
         dwReturn["KADBMKT"] = " ".PadRight(16 ); 
         dwReturn["KADBMGKZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBMGKT1"] = " ".PadRight(16 ); 
         dwReturn["KADBMGKZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBMGKT2"] = " ".PadRight(16 ); 
         dwReturn["KADBMGKZS3"] = " ".PadRight(2 ); 
         dwReturn["KADBMGKT3"] = " ".PadRight(16 ); 
         dwReturn["KADBMGKZS4"] = " ".PadRight(2 ); 
         dwReturn["KADBMGKT4"] = " ".PadRight(16 ); 
         dwReturn["KADBMGKZS5"] = " ".PadRight(2 ); 
         dwReturn["KADBMGKT5"] = " ".PadRight(16 ); 
         dwReturn["KADBFFKZS"] = " ".PadRight(2 ); 
         dwReturn["KADBFFKT"] = " ".PadRight(16 ); 
         dwReturn["KADBFEKZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBFEKT1"] = " ".PadRight(16 ); 
         dwReturn["KADBFEKZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBFEKT2"] = " ".PadRight(16 ); 
         dwReturn["KADBFEKZS3"] = " ".PadRight(2 ); 
         dwReturn["KADBFEKT3"] = " ".PadRight(16 ); 
         dwReturn["KADBFEKZS4"] = " ".PadRight(2 ); 
         dwReturn["KADBFEKT4"] = " ".PadRight(16 ); 
         dwReturn["KADBFEKZS5"] = " ".PadRight(2 ); 
         dwReturn["KADBFEKT5"] = " ".PadRight(16 ); 
         dwReturn["KADBFGKZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBFGKT1"] = " ".PadRight(16 ); 
         dwReturn["KADBFGKZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBFGKT2"] = " ".PadRight(16 ); 
         dwReturn["KADBFGKZS3"] = " ".PadRight(2 ); 
         dwReturn["KADBFGKT3"] = " ".PadRight(16 ); 
         dwReturn["KADBFGKZS4"] = " ".PadRight(2 ); 
         dwReturn["KADBFGKT4"] = " ".PadRight(16 ); 
         dwReturn["KADBFGKZS5"] = " ".PadRight(2 ); 
         dwReturn["KADBFGKT5"] = " ".PadRight(16 ); 
         dwReturn["KADBSEKFZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSEKFT"] = " ".PadRight(16 ); 
         dwReturn["KADBWAGZS"] = " ".PadRight(2 ); 
         dwReturn["KADBWAGT"] = " ".PadRight(16 ); 
         dwReturn["KADBMEZS"] = " ".PadRight(2 ); 
         dwReturn["KADBMET"] = " ".PadRight(16 ); 
         dwReturn["KADBVPZS"] = " ".PadRight(2 ); 
         dwReturn["KADBVPT"] = " ".PadRight(16 ); 
         dwReturn["KADBPART1"] = " ".PadRight(5 ); 
         dwReturn["KADBPAZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBPAT1"] = " ".PadRight(16 ); 
         dwReturn["KADBPART2"] = " ".PadRight(5 ); 
         dwReturn["KADBPAZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBPAT2"] = " ".PadRight(16 ); 
         dwReturn["KADBKOGRP1"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS1"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS1"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ1"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT1"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP2"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS2"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS2"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ2"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT2"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP3"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS3"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS3"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS3"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ3"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT3"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP4"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS4"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS4"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS4"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ4"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT4"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP5"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS5"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS5"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS5"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ5"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT5"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP6"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS6"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS6"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS6"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ6"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT6"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP7"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS7"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS7"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS7"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ7"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT7"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP8"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS8"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS8"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS8"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ8"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT8"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP9"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS9"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS9"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS9"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ9"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT9"] = " ".PadRight(6 ); 
         dwReturn["KADBKOGRP10"] = " ".PadRight(4 ); 
         dwReturn["KADBVVGKBZS10"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKZS10"] = " ".PadRight(2 ); 
         dwReturn["KADBVVGKBAS10"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKPROZ10"] = " ".PadRight(1 ); 
         dwReturn["KADBVVGKT10"] = " ".PadRight(6 ); 
         dwReturn["KADBSCHKKZ"] = " ".PadRight(1 ); 
         dwReturn["KADBSCHKT"] = " ".PadRight(6 ); 
         dwReturn["KADBVERPBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBVERPZS"] = " ".PadRight(2 ); 
         dwReturn["KADBVERPBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBVERPPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBVERPT"] = " ".PadRight(6 ); 
         dwReturn["KADBVERSBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBVERSZS"] = " ".PadRight(2 ); 
         dwReturn["KADBVERSBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBVERSPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBVERST"] = " ".PadRight(6 ); 
         dwReturn["KADBFRABZS"] = " ".PadRight(2 ); 
         dwReturn["KADBFRAZS"] = " ".PadRight(2 ); 
         dwReturn["KADBFRABAS"] = " ".PadRight(1 ); 
         dwReturn["KADBFRAPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBFRAT"] = " ".PadRight(6 ); 
         dwReturn["KADBZOLLBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBZOLLZS"] = " ".PadRight(2 ); 
         dwReturn["KADBZOLLBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBZOLLPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBZOLLT"] = " ".PadRight(6 ); 
         dwReturn["KADBPROVBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBPROVZS"] = " ".PadRight(2 ); 
         dwReturn["KADBPROVBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBPROVPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBPROVT"] = " ".PadRight(6 ); 
         dwReturn["KADBBONBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBBONZS"] = " ".PadRight(2 ); 
         dwReturn["KADBBONBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBBONPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBBONT"] = " ".PadRight(6 ); 
         dwReturn["KADBSKTBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSKTZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSKTBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBSKTPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBSKTT"] = " ".PadRight(6 ); 
         dwReturn["KADBEVBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBEVZS"] = " ".PadRight(2 ); 
         dwReturn["KADBEVBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBEVPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBEVT"] = " ".PadRight(6 ); 
         dwReturn["KADBSEKSBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSEKSZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSEKSBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBSEKSPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBSEKST"] = " ".PadRight(6 ); 
         dwReturn["KADBSDBBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSDBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBSDBBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBSDBPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBSDBT"] = " ".PadRight(6 ); 
         dwReturn["KADBZINSBZS"] = " ".PadRight(2 ); 
         dwReturn["KADBZINSZS"] = " ".PadRight(2 ); 
         dwReturn["KADBZINSBAS"] = " ".PadRight(1 ); 
         dwReturn["KADBZINSPROZ"] = " ".PadRight(1 ); 
         dwReturn["KADBZINST"] = " ".PadRight(6 ); 
         dwReturn["KADBVWET1"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET2"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET3"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET4"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET5"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET6"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET7"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET8"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET9"] = " ".PadRight(12 ); 
         dwReturn["KADBVWET10"] = " ".PadRight(12 ); 
         dwReturn["KADBFILLER"] = " ".PadRight(103 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapKADBZU(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveKADBZU(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryKADBZU(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapKADBZU(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertKADBZU(dwLocal, ITXDBVERSION);
            }
            UpdateKADBZU(dwLocal);
        }
        public void InsertKADBZU(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO KADBZU(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryKADBZU(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM KADBZU WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM KADBZU  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "KADBZU";
            Return = Result;
            return Return;
        }
        public void DeleteKADBZU(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM KADBZU   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateKADBZU(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE KADBZU SET "
                    +"KADBMANDANT= :KADBMANDANT,"
                    +"KADBDAT= :KADBDAT,"
                    +"KADBAENZL= :KADBAENZL,"
                    +"KADBAENB= :KADBAENB,"
                    +"KADBAEND= :KADBAEND,"
                    +"KADBNEUB= :KADBNEUB,"
                    +"KADBNEUD= :KADBNEUD,"
                    +"KADBHWZS= :KADBHWZS,"
                    +"KADBHWT= :KADBHWT,"
                    +"KADBMKZS= :KADBMKZS,"
                    +"KADBMKT= :KADBMKT,"
                    +"KADBMGKZS1= :KADBMGKZS1,"
                    +"KADBMGKT1= :KADBMGKT1,"
                    +"KADBMGKZS2= :KADBMGKZS2,"
                    +"KADBMGKT2= :KADBMGKT2,"
                    +"KADBMGKZS3= :KADBMGKZS3,"
                    +"KADBMGKT3= :KADBMGKT3,"
                    +"KADBMGKZS4= :KADBMGKZS4,"
                    +"KADBMGKT4= :KADBMGKT4,"
                    +"KADBMGKZS5= :KADBMGKZS5,"
                    +"KADBMGKT5= :KADBMGKT5,"
                    +"KADBFFKZS= :KADBFFKZS,"
                    +"KADBFFKT= :KADBFFKT,"
                    +"KADBFEKZS1= :KADBFEKZS1,"
                    +"KADBFEKT1= :KADBFEKT1,"
                    +"KADBFEKZS2= :KADBFEKZS2,"
                    +"KADBFEKT2= :KADBFEKT2,"
                    +"KADBFEKZS3= :KADBFEKZS3,"
                    +"KADBFEKT3= :KADBFEKT3,"
                    +"KADBFEKZS4= :KADBFEKZS4,"
                    +"KADBFEKT4= :KADBFEKT4,"
                    +"KADBFEKZS5= :KADBFEKZS5,"
                    +"KADBFEKT5= :KADBFEKT5,"
                    +"KADBFGKZS1= :KADBFGKZS1,"
                    +"KADBFGKT1= :KADBFGKT1,"
                    +"KADBFGKZS2= :KADBFGKZS2,"
                    +"KADBFGKT2= :KADBFGKT2,"
                    +"KADBFGKZS3= :KADBFGKZS3,"
                    +"KADBFGKT3= :KADBFGKT3,"
                    +"KADBFGKZS4= :KADBFGKZS4,"
                    +"KADBFGKT4= :KADBFGKT4,"
                    +"KADBFGKZS5= :KADBFGKZS5,"
                    +"KADBFGKT5= :KADBFGKT5,"
                    +"KADBSEKFZS= :KADBSEKFZS,"
                    +"KADBSEKFT= :KADBSEKFT,"
                    +"KADBWAGZS= :KADBWAGZS,"
                    +"KADBWAGT= :KADBWAGT,"
                    +"KADBMEZS= :KADBMEZS,"
                    +"KADBMET= :KADBMET,"
                    +"KADBVPZS= :KADBVPZS,"
                    +"KADBVPT= :KADBVPT,"
                    +"KADBPART1= :KADBPART1,"
                    +"KADBPAZS1= :KADBPAZS1,"
                    +"KADBPAT1= :KADBPAT1,"
                    +"KADBPART2= :KADBPART2,"
                    +"KADBPAZS2= :KADBPAZS2,"
                    +"KADBPAT2= :KADBPAT2,"
                    +"KADBKOGRP1= :KADBKOGRP1,"
                    +"KADBVVGKBZS1= :KADBVVGKBZS1,"
                    +"KADBVVGKZS1= :KADBVVGKZS1,"
                    +"KADBVVGKBAS1= :KADBVVGKBAS1,"
                    +"KADBVVGKPROZ1= :KADBVVGKPROZ1,"
                    +"KADBVVGKT1= :KADBVVGKT1,"
                    +"KADBKOGRP2= :KADBKOGRP2,"
                    +"KADBVVGKBZS2= :KADBVVGKBZS2,"
                    +"KADBVVGKZS2= :KADBVVGKZS2,"
                    +"KADBVVGKBAS2= :KADBVVGKBAS2,"
                    +"KADBVVGKPROZ2= :KADBVVGKPROZ2,"
                    +"KADBVVGKT2= :KADBVVGKT2,"
                    +"KADBKOGRP3= :KADBKOGRP3,"
                    +"KADBVVGKBZS3= :KADBVVGKBZS3,"
                    +"KADBVVGKZS3= :KADBVVGKZS3,"
                    +"KADBVVGKBAS3= :KADBVVGKBAS3,"
                    +"KADBVVGKPROZ3= :KADBVVGKPROZ3,"
                    +"KADBVVGKT3= :KADBVVGKT3,"
                    +"KADBKOGRP4= :KADBKOGRP4,"
                    +"KADBVVGKBZS4= :KADBVVGKBZS4,"
                    +"KADBVVGKZS4= :KADBVVGKZS4,"
                    +"KADBVVGKBAS4= :KADBVVGKBAS4,"
                    +"KADBVVGKPROZ4= :KADBVVGKPROZ4,"
                    +"KADBVVGKT4= :KADBVVGKT4,"
                    +"KADBKOGRP5= :KADBKOGRP5,"
                    +"KADBVVGKBZS5= :KADBVVGKBZS5,"
                    +"KADBVVGKZS5= :KADBVVGKZS5,"
                    +"KADBVVGKBAS5= :KADBVVGKBAS5,"
                    +"KADBVVGKPROZ5= :KADBVVGKPROZ5,"
                    +"KADBVVGKT5= :KADBVVGKT5,"
                    +"KADBKOGRP6= :KADBKOGRP6,"
                    +"KADBVVGKBZS6= :KADBVVGKBZS6,"
                    +"KADBVVGKZS6= :KADBVVGKZS6,"
                    +"KADBVVGKBAS6= :KADBVVGKBAS6,"
                    +"KADBVVGKPROZ6= :KADBVVGKPROZ6,"
                    +"KADBVVGKT6= :KADBVVGKT6,"
                    +"KADBKOGRP7= :KADBKOGRP7,"
                    +"KADBVVGKBZS7= :KADBVVGKBZS7,"
                    +"KADBVVGKZS7= :KADBVVGKZS7,"
                    +"KADBVVGKBAS7= :KADBVVGKBAS7,"
                    +"KADBVVGKPROZ7= :KADBVVGKPROZ7,"
                    +"KADBVVGKT7= :KADBVVGKT7,"
                    +"KADBKOGRP8= :KADBKOGRP8,"
                    +"KADBVVGKBZS8= :KADBVVGKBZS8,"
                    +"KADBVVGKZS8= :KADBVVGKZS8,"
                    +"KADBVVGKBAS8= :KADBVVGKBAS8,"
                    +"KADBVVGKPROZ8= :KADBVVGKPROZ8,"
                    +"KADBVVGKT8= :KADBVVGKT8,"
                    +"KADBKOGRP9= :KADBKOGRP9,"
                    +"KADBVVGKBZS9= :KADBVVGKBZS9,"
                    +"KADBVVGKZS9= :KADBVVGKZS9,"
                    +"KADBVVGKBAS9= :KADBVVGKBAS9,"
                    +"KADBVVGKPROZ9= :KADBVVGKPROZ9,"
                    +"KADBVVGKT9= :KADBVVGKT9,"
                    +"KADBKOGRP10= :KADBKOGRP10,"
                    +"KADBVVGKBZS10= :KADBVVGKBZS10,"
                    +"KADBVVGKZS10= :KADBVVGKZS10,"
                    +"KADBVVGKBAS10= :KADBVVGKBAS10,"
                    +"KADBVVGKPROZ10= :KADBVVGKPROZ10,"
                    +"KADBVVGKT10= :KADBVVGKT10,"
                    +"KADBSCHKKZ= :KADBSCHKKZ,"
                    +"KADBSCHKT= :KADBSCHKT,"
                    +"KADBVERPBZS= :KADBVERPBZS,"
                    +"KADBVERPZS= :KADBVERPZS,"
                    +"KADBVERPBAS= :KADBVERPBAS,"
                    +"KADBVERPPROZ= :KADBVERPPROZ,"
                    +"KADBVERPT= :KADBVERPT,"
                    +"KADBVERSBZS= :KADBVERSBZS,"
                    +"KADBVERSZS= :KADBVERSZS,"
                    +"KADBVERSBAS= :KADBVERSBAS,"
                    +"KADBVERSPROZ= :KADBVERSPROZ,"
                    +"KADBVERST= :KADBVERST,"
                    +"KADBFRABZS= :KADBFRABZS,"
                    +"KADBFRAZS= :KADBFRAZS,"
                    +"KADBFRABAS= :KADBFRABAS,"
                    +"KADBFRAPROZ= :KADBFRAPROZ,"
                    +"KADBFRAT= :KADBFRAT,"
                    +"KADBZOLLBZS= :KADBZOLLBZS,"
                    +"KADBZOLLZS= :KADBZOLLZS,"
                    +"KADBZOLLBAS= :KADBZOLLBAS,"
                    +"KADBZOLLPROZ= :KADBZOLLPROZ,"
                    +"KADBZOLLT= :KADBZOLLT,"
                    +"KADBPROVBZS= :KADBPROVBZS,"
                    +"KADBPROVZS= :KADBPROVZS,"
                    +"KADBPROVBAS= :KADBPROVBAS,"
                    +"KADBPROVPROZ= :KADBPROVPROZ,"
                    +"KADBPROVT= :KADBPROVT,"
                    +"KADBBONBZS= :KADBBONBZS,"
                    +"KADBBONZS= :KADBBONZS,"
                    +"KADBBONBAS= :KADBBONBAS,"
                    +"KADBBONPROZ= :KADBBONPROZ,"
                    +"KADBBONT= :KADBBONT,"
                    +"KADBSKTBZS= :KADBSKTBZS,"
                    +"KADBSKTZS= :KADBSKTZS,"
                    +"KADBSKTBAS= :KADBSKTBAS,"
                    +"KADBSKTPROZ= :KADBSKTPROZ,"
                    +"KADBSKTT= :KADBSKTT,"
                    +"KADBEVBZS= :KADBEVBZS,"
                    +"KADBEVZS= :KADBEVZS,"
                    +"KADBEVBAS= :KADBEVBAS,"
                    +"KADBEVPROZ= :KADBEVPROZ,"
                    +"KADBEVT= :KADBEVT,"
                    +"KADBSEKSBZS= :KADBSEKSBZS,"
                    +"KADBSEKSZS= :KADBSEKSZS,"
                    +"KADBSEKSBAS= :KADBSEKSBAS,"
                    +"KADBSEKSPROZ= :KADBSEKSPROZ,"
                    +"KADBSEKST= :KADBSEKST,"
                    +"KADBSDBBZS= :KADBSDBBZS,"
                    +"KADBSDBZS= :KADBSDBZS,"
                    +"KADBSDBBAS= :KADBSDBBAS,"
                    +"KADBSDBPROZ= :KADBSDBPROZ,"
                    +"KADBSDBT= :KADBSDBT,"
                    +"KADBZINSBZS= :KADBZINSBZS,"
                    +"KADBZINSZS= :KADBZINSZS,"
                    +"KADBZINSBAS= :KADBZINSBAS,"
                    +"KADBZINSPROZ= :KADBZINSPROZ,"
                    +"KADBZINST= :KADBZINST,"
                    +"KADBVWET1= :KADBVWET1,"
                    +"KADBVWET2= :KADBVWET2,"
                    +"KADBVWET3= :KADBVWET3,"
                    +"KADBVWET4= :KADBVWET4,"
                    +"KADBVWET5= :KADBVWET5,"
                    +"KADBVWET6= :KADBVWET6,"
                    +"KADBVWET7= :KADBVWET7,"
                    +"KADBVWET8= :KADBVWET8,"
                    +"KADBVWET9= :KADBVWET9,"
                    +"KADBVWET10= :KADBVWET10,"
                    +"KADBFILLER= :KADBFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("KADBMANDANT", OracleType.NVarChar).Value = dwData["KADBMANDANT"].ToString(); 
          or1.Parameters.Add("KADBDAT", OracleType.NVarChar).Value = dwData["KADBDAT"].ToString(); 
          or1.Parameters.Add("KADBAENZL", OracleType.NVarChar).Value = dwData["KADBAENZL"].ToString(); 
          or1.Parameters.Add("KADBAENB", OracleType.NVarChar).Value = dwData["KADBAENB"].ToString(); 
          or1.Parameters.Add("KADBAEND", OracleType.NVarChar).Value = dwData["KADBAEND"].ToString(); 
          or1.Parameters.Add("KADBNEUB", OracleType.NVarChar).Value = dwData["KADBNEUB"].ToString(); 
          or1.Parameters.Add("KADBNEUD", OracleType.NVarChar).Value = dwData["KADBNEUD"].ToString(); 
          or1.Parameters.Add("KADBHWZS", OracleType.NVarChar).Value = dwData["KADBHWZS"].ToString(); 
          or1.Parameters.Add("KADBHWT", OracleType.NVarChar).Value = dwData["KADBHWT"].ToString(); 
          or1.Parameters.Add("KADBMKZS", OracleType.NVarChar).Value = dwData["KADBMKZS"].ToString(); 
          or1.Parameters.Add("KADBMKT", OracleType.NVarChar).Value = dwData["KADBMKT"].ToString(); 
          or1.Parameters.Add("KADBMGKZS1", OracleType.NVarChar).Value = dwData["KADBMGKZS1"].ToString(); 
          or1.Parameters.Add("KADBMGKT1", OracleType.NVarChar).Value = dwData["KADBMGKT1"].ToString(); 
          or1.Parameters.Add("KADBMGKZS2", OracleType.NVarChar).Value = dwData["KADBMGKZS2"].ToString(); 
          or1.Parameters.Add("KADBMGKT2", OracleType.NVarChar).Value = dwData["KADBMGKT2"].ToString(); 
          or1.Parameters.Add("KADBMGKZS3", OracleType.NVarChar).Value = dwData["KADBMGKZS3"].ToString(); 
          or1.Parameters.Add("KADBMGKT3", OracleType.NVarChar).Value = dwData["KADBMGKT3"].ToString(); 
          or1.Parameters.Add("KADBMGKZS4", OracleType.NVarChar).Value = dwData["KADBMGKZS4"].ToString(); 
          or1.Parameters.Add("KADBMGKT4", OracleType.NVarChar).Value = dwData["KADBMGKT4"].ToString(); 
          or1.Parameters.Add("KADBMGKZS5", OracleType.NVarChar).Value = dwData["KADBMGKZS5"].ToString(); 
          or1.Parameters.Add("KADBMGKT5", OracleType.NVarChar).Value = dwData["KADBMGKT5"].ToString(); 
          or1.Parameters.Add("KADBFFKZS", OracleType.NVarChar).Value = dwData["KADBFFKZS"].ToString(); 
          or1.Parameters.Add("KADBFFKT", OracleType.NVarChar).Value = dwData["KADBFFKT"].ToString(); 
          or1.Parameters.Add("KADBFEKZS1", OracleType.NVarChar).Value = dwData["KADBFEKZS1"].ToString(); 
          or1.Parameters.Add("KADBFEKT1", OracleType.NVarChar).Value = dwData["KADBFEKT1"].ToString(); 
          or1.Parameters.Add("KADBFEKZS2", OracleType.NVarChar).Value = dwData["KADBFEKZS2"].ToString(); 
          or1.Parameters.Add("KADBFEKT2", OracleType.NVarChar).Value = dwData["KADBFEKT2"].ToString(); 
          or1.Parameters.Add("KADBFEKZS3", OracleType.NVarChar).Value = dwData["KADBFEKZS3"].ToString(); 
          or1.Parameters.Add("KADBFEKT3", OracleType.NVarChar).Value = dwData["KADBFEKT3"].ToString(); 
          or1.Parameters.Add("KADBFEKZS4", OracleType.NVarChar).Value = dwData["KADBFEKZS4"].ToString(); 
          or1.Parameters.Add("KADBFEKT4", OracleType.NVarChar).Value = dwData["KADBFEKT4"].ToString(); 
          or1.Parameters.Add("KADBFEKZS5", OracleType.NVarChar).Value = dwData["KADBFEKZS5"].ToString(); 
          or1.Parameters.Add("KADBFEKT5", OracleType.NVarChar).Value = dwData["KADBFEKT5"].ToString(); 
          or1.Parameters.Add("KADBFGKZS1", OracleType.NVarChar).Value = dwData["KADBFGKZS1"].ToString(); 
          or1.Parameters.Add("KADBFGKT1", OracleType.NVarChar).Value = dwData["KADBFGKT1"].ToString(); 
          or1.Parameters.Add("KADBFGKZS2", OracleType.NVarChar).Value = dwData["KADBFGKZS2"].ToString(); 
          or1.Parameters.Add("KADBFGKT2", OracleType.NVarChar).Value = dwData["KADBFGKT2"].ToString(); 
          or1.Parameters.Add("KADBFGKZS3", OracleType.NVarChar).Value = dwData["KADBFGKZS3"].ToString(); 
          or1.Parameters.Add("KADBFGKT3", OracleType.NVarChar).Value = dwData["KADBFGKT3"].ToString(); 
          or1.Parameters.Add("KADBFGKZS4", OracleType.NVarChar).Value = dwData["KADBFGKZS4"].ToString(); 
          or1.Parameters.Add("KADBFGKT4", OracleType.NVarChar).Value = dwData["KADBFGKT4"].ToString(); 
          or1.Parameters.Add("KADBFGKZS5", OracleType.NVarChar).Value = dwData["KADBFGKZS5"].ToString(); 
          or1.Parameters.Add("KADBFGKT5", OracleType.NVarChar).Value = dwData["KADBFGKT5"].ToString(); 
          or1.Parameters.Add("KADBSEKFZS", OracleType.NVarChar).Value = dwData["KADBSEKFZS"].ToString(); 
          or1.Parameters.Add("KADBSEKFT", OracleType.NVarChar).Value = dwData["KADBSEKFT"].ToString(); 
          or1.Parameters.Add("KADBWAGZS", OracleType.NVarChar).Value = dwData["KADBWAGZS"].ToString(); 
          or1.Parameters.Add("KADBWAGT", OracleType.NVarChar).Value = dwData["KADBWAGT"].ToString(); 
          or1.Parameters.Add("KADBMEZS", OracleType.NVarChar).Value = dwData["KADBMEZS"].ToString(); 
          or1.Parameters.Add("KADBMET", OracleType.NVarChar).Value = dwData["KADBMET"].ToString(); 
          or1.Parameters.Add("KADBVPZS", OracleType.NVarChar).Value = dwData["KADBVPZS"].ToString(); 
          or1.Parameters.Add("KADBVPT", OracleType.NVarChar).Value = dwData["KADBVPT"].ToString(); 
          or1.Parameters.Add("KADBPART1", OracleType.NVarChar).Value = dwData["KADBPART1"].ToString(); 
          or1.Parameters.Add("KADBPAZS1", OracleType.NVarChar).Value = dwData["KADBPAZS1"].ToString(); 
          or1.Parameters.Add("KADBPAT1", OracleType.NVarChar).Value = dwData["KADBPAT1"].ToString(); 
          or1.Parameters.Add("KADBPART2", OracleType.NVarChar).Value = dwData["KADBPART2"].ToString(); 
          or1.Parameters.Add("KADBPAZS2", OracleType.NVarChar).Value = dwData["KADBPAZS2"].ToString(); 
          or1.Parameters.Add("KADBPAT2", OracleType.NVarChar).Value = dwData["KADBPAT2"].ToString(); 
          or1.Parameters.Add("KADBKOGRP1", OracleType.NVarChar).Value = dwData["KADBKOGRP1"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS1", OracleType.NVarChar).Value = dwData["KADBVVGKBZS1"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS1", OracleType.NVarChar).Value = dwData["KADBVVGKZS1"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS1", OracleType.NVarChar).Value = dwData["KADBVVGKBAS1"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ1", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ1"].ToString(); 
          or1.Parameters.Add("KADBVVGKT1", OracleType.NVarChar).Value = dwData["KADBVVGKT1"].ToString(); 
          or1.Parameters.Add("KADBKOGRP2", OracleType.NVarChar).Value = dwData["KADBKOGRP2"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS2", OracleType.NVarChar).Value = dwData["KADBVVGKBZS2"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS2", OracleType.NVarChar).Value = dwData["KADBVVGKZS2"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS2", OracleType.NVarChar).Value = dwData["KADBVVGKBAS2"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ2", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ2"].ToString(); 
          or1.Parameters.Add("KADBVVGKT2", OracleType.NVarChar).Value = dwData["KADBVVGKT2"].ToString(); 
          or1.Parameters.Add("KADBKOGRP3", OracleType.NVarChar).Value = dwData["KADBKOGRP3"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS3", OracleType.NVarChar).Value = dwData["KADBVVGKBZS3"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS3", OracleType.NVarChar).Value = dwData["KADBVVGKZS3"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS3", OracleType.NVarChar).Value = dwData["KADBVVGKBAS3"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ3", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ3"].ToString(); 
          or1.Parameters.Add("KADBVVGKT3", OracleType.NVarChar).Value = dwData["KADBVVGKT3"].ToString(); 
          or1.Parameters.Add("KADBKOGRP4", OracleType.NVarChar).Value = dwData["KADBKOGRP4"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS4", OracleType.NVarChar).Value = dwData["KADBVVGKBZS4"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS4", OracleType.NVarChar).Value = dwData["KADBVVGKZS4"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS4", OracleType.NVarChar).Value = dwData["KADBVVGKBAS4"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ4", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ4"].ToString(); 
          or1.Parameters.Add("KADBVVGKT4", OracleType.NVarChar).Value = dwData["KADBVVGKT4"].ToString(); 
          or1.Parameters.Add("KADBKOGRP5", OracleType.NVarChar).Value = dwData["KADBKOGRP5"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS5", OracleType.NVarChar).Value = dwData["KADBVVGKBZS5"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS5", OracleType.NVarChar).Value = dwData["KADBVVGKZS5"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS5", OracleType.NVarChar).Value = dwData["KADBVVGKBAS5"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ5", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ5"].ToString(); 
          or1.Parameters.Add("KADBVVGKT5", OracleType.NVarChar).Value = dwData["KADBVVGKT5"].ToString(); 
          or1.Parameters.Add("KADBKOGRP6", OracleType.NVarChar).Value = dwData["KADBKOGRP6"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS6", OracleType.NVarChar).Value = dwData["KADBVVGKBZS6"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS6", OracleType.NVarChar).Value = dwData["KADBVVGKZS6"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS6", OracleType.NVarChar).Value = dwData["KADBVVGKBAS6"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ6", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ6"].ToString(); 
          or1.Parameters.Add("KADBVVGKT6", OracleType.NVarChar).Value = dwData["KADBVVGKT6"].ToString(); 
          or1.Parameters.Add("KADBKOGRP7", OracleType.NVarChar).Value = dwData["KADBKOGRP7"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS7", OracleType.NVarChar).Value = dwData["KADBVVGKBZS7"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS7", OracleType.NVarChar).Value = dwData["KADBVVGKZS7"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS7", OracleType.NVarChar).Value = dwData["KADBVVGKBAS7"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ7", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ7"].ToString(); 
          or1.Parameters.Add("KADBVVGKT7", OracleType.NVarChar).Value = dwData["KADBVVGKT7"].ToString(); 
          or1.Parameters.Add("KADBKOGRP8", OracleType.NVarChar).Value = dwData["KADBKOGRP8"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS8", OracleType.NVarChar).Value = dwData["KADBVVGKBZS8"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS8", OracleType.NVarChar).Value = dwData["KADBVVGKZS8"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS8", OracleType.NVarChar).Value = dwData["KADBVVGKBAS8"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ8", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ8"].ToString(); 
          or1.Parameters.Add("KADBVVGKT8", OracleType.NVarChar).Value = dwData["KADBVVGKT8"].ToString(); 
          or1.Parameters.Add("KADBKOGRP9", OracleType.NVarChar).Value = dwData["KADBKOGRP9"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS9", OracleType.NVarChar).Value = dwData["KADBVVGKBZS9"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS9", OracleType.NVarChar).Value = dwData["KADBVVGKZS9"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS9", OracleType.NVarChar).Value = dwData["KADBVVGKBAS9"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ9", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ9"].ToString(); 
          or1.Parameters.Add("KADBVVGKT9", OracleType.NVarChar).Value = dwData["KADBVVGKT9"].ToString(); 
          or1.Parameters.Add("KADBKOGRP10", OracleType.NVarChar).Value = dwData["KADBKOGRP10"].ToString(); 
          or1.Parameters.Add("KADBVVGKBZS10", OracleType.NVarChar).Value = dwData["KADBVVGKBZS10"].ToString(); 
          or1.Parameters.Add("KADBVVGKZS10", OracleType.NVarChar).Value = dwData["KADBVVGKZS10"].ToString(); 
          or1.Parameters.Add("KADBVVGKBAS10", OracleType.NVarChar).Value = dwData["KADBVVGKBAS10"].ToString(); 
          or1.Parameters.Add("KADBVVGKPROZ10", OracleType.NVarChar).Value = dwData["KADBVVGKPROZ10"].ToString(); 
          or1.Parameters.Add("KADBVVGKT10", OracleType.NVarChar).Value = dwData["KADBVVGKT10"].ToString(); 
          or1.Parameters.Add("KADBSCHKKZ", OracleType.NVarChar).Value = dwData["KADBSCHKKZ"].ToString(); 
          or1.Parameters.Add("KADBSCHKT", OracleType.NVarChar).Value = dwData["KADBSCHKT"].ToString(); 
          or1.Parameters.Add("KADBVERPBZS", OracleType.NVarChar).Value = dwData["KADBVERPBZS"].ToString(); 
          or1.Parameters.Add("KADBVERPZS", OracleType.NVarChar).Value = dwData["KADBVERPZS"].ToString(); 
          or1.Parameters.Add("KADBVERPBAS", OracleType.NVarChar).Value = dwData["KADBVERPBAS"].ToString(); 
          or1.Parameters.Add("KADBVERPPROZ", OracleType.NVarChar).Value = dwData["KADBVERPPROZ"].ToString(); 
          or1.Parameters.Add("KADBVERPT", OracleType.NVarChar).Value = dwData["KADBVERPT"].ToString(); 
          or1.Parameters.Add("KADBVERSBZS", OracleType.NVarChar).Value = dwData["KADBVERSBZS"].ToString(); 
          or1.Parameters.Add("KADBVERSZS", OracleType.NVarChar).Value = dwData["KADBVERSZS"].ToString(); 
          or1.Parameters.Add("KADBVERSBAS", OracleType.NVarChar).Value = dwData["KADBVERSBAS"].ToString(); 
          or1.Parameters.Add("KADBVERSPROZ", OracleType.NVarChar).Value = dwData["KADBVERSPROZ"].ToString(); 
          or1.Parameters.Add("KADBVERST", OracleType.NVarChar).Value = dwData["KADBVERST"].ToString(); 
          or1.Parameters.Add("KADBFRABZS", OracleType.NVarChar).Value = dwData["KADBFRABZS"].ToString(); 
          or1.Parameters.Add("KADBFRAZS", OracleType.NVarChar).Value = dwData["KADBFRAZS"].ToString(); 
          or1.Parameters.Add("KADBFRABAS", OracleType.NVarChar).Value = dwData["KADBFRABAS"].ToString(); 
          or1.Parameters.Add("KADBFRAPROZ", OracleType.NVarChar).Value = dwData["KADBFRAPROZ"].ToString(); 
          or1.Parameters.Add("KADBFRAT", OracleType.NVarChar).Value = dwData["KADBFRAT"].ToString(); 
          or1.Parameters.Add("KADBZOLLBZS", OracleType.NVarChar).Value = dwData["KADBZOLLBZS"].ToString(); 
          or1.Parameters.Add("KADBZOLLZS", OracleType.NVarChar).Value = dwData["KADBZOLLZS"].ToString(); 
          or1.Parameters.Add("KADBZOLLBAS", OracleType.NVarChar).Value = dwData["KADBZOLLBAS"].ToString(); 
          or1.Parameters.Add("KADBZOLLPROZ", OracleType.NVarChar).Value = dwData["KADBZOLLPROZ"].ToString(); 
          or1.Parameters.Add("KADBZOLLT", OracleType.NVarChar).Value = dwData["KADBZOLLT"].ToString(); 
          or1.Parameters.Add("KADBPROVBZS", OracleType.NVarChar).Value = dwData["KADBPROVBZS"].ToString(); 
          or1.Parameters.Add("KADBPROVZS", OracleType.NVarChar).Value = dwData["KADBPROVZS"].ToString(); 
          or1.Parameters.Add("KADBPROVBAS", OracleType.NVarChar).Value = dwData["KADBPROVBAS"].ToString(); 
          or1.Parameters.Add("KADBPROVPROZ", OracleType.NVarChar).Value = dwData["KADBPROVPROZ"].ToString(); 
          or1.Parameters.Add("KADBPROVT", OracleType.NVarChar).Value = dwData["KADBPROVT"].ToString(); 
          or1.Parameters.Add("KADBBONBZS", OracleType.NVarChar).Value = dwData["KADBBONBZS"].ToString(); 
          or1.Parameters.Add("KADBBONZS", OracleType.NVarChar).Value = dwData["KADBBONZS"].ToString(); 
          or1.Parameters.Add("KADBBONBAS", OracleType.NVarChar).Value = dwData["KADBBONBAS"].ToString(); 
          or1.Parameters.Add("KADBBONPROZ", OracleType.NVarChar).Value = dwData["KADBBONPROZ"].ToString(); 
          or1.Parameters.Add("KADBBONT", OracleType.NVarChar).Value = dwData["KADBBONT"].ToString(); 
          or1.Parameters.Add("KADBSKTBZS", OracleType.NVarChar).Value = dwData["KADBSKTBZS"].ToString(); 
          or1.Parameters.Add("KADBSKTZS", OracleType.NVarChar).Value = dwData["KADBSKTZS"].ToString(); 
          or1.Parameters.Add("KADBSKTBAS", OracleType.NVarChar).Value = dwData["KADBSKTBAS"].ToString(); 
          or1.Parameters.Add("KADBSKTPROZ", OracleType.NVarChar).Value = dwData["KADBSKTPROZ"].ToString(); 
          or1.Parameters.Add("KADBSKTT", OracleType.NVarChar).Value = dwData["KADBSKTT"].ToString(); 
          or1.Parameters.Add("KADBEVBZS", OracleType.NVarChar).Value = dwData["KADBEVBZS"].ToString(); 
          or1.Parameters.Add("KADBEVZS", OracleType.NVarChar).Value = dwData["KADBEVZS"].ToString(); 
          or1.Parameters.Add("KADBEVBAS", OracleType.NVarChar).Value = dwData["KADBEVBAS"].ToString(); 
          or1.Parameters.Add("KADBEVPROZ", OracleType.NVarChar).Value = dwData["KADBEVPROZ"].ToString(); 
          or1.Parameters.Add("KADBEVT", OracleType.NVarChar).Value = dwData["KADBEVT"].ToString(); 
          or1.Parameters.Add("KADBSEKSBZS", OracleType.NVarChar).Value = dwData["KADBSEKSBZS"].ToString(); 
          or1.Parameters.Add("KADBSEKSZS", OracleType.NVarChar).Value = dwData["KADBSEKSZS"].ToString(); 
          or1.Parameters.Add("KADBSEKSBAS", OracleType.NVarChar).Value = dwData["KADBSEKSBAS"].ToString(); 
          or1.Parameters.Add("KADBSEKSPROZ", OracleType.NVarChar).Value = dwData["KADBSEKSPROZ"].ToString(); 
          or1.Parameters.Add("KADBSEKST", OracleType.NVarChar).Value = dwData["KADBSEKST"].ToString(); 
          or1.Parameters.Add("KADBSDBBZS", OracleType.NVarChar).Value = dwData["KADBSDBBZS"].ToString(); 
          or1.Parameters.Add("KADBSDBZS", OracleType.NVarChar).Value = dwData["KADBSDBZS"].ToString(); 
          or1.Parameters.Add("KADBSDBBAS", OracleType.NVarChar).Value = dwData["KADBSDBBAS"].ToString(); 
          or1.Parameters.Add("KADBSDBPROZ", OracleType.NVarChar).Value = dwData["KADBSDBPROZ"].ToString(); 
          or1.Parameters.Add("KADBSDBT", OracleType.NVarChar).Value = dwData["KADBSDBT"].ToString(); 
          or1.Parameters.Add("KADBZINSBZS", OracleType.NVarChar).Value = dwData["KADBZINSBZS"].ToString(); 
          or1.Parameters.Add("KADBZINSZS", OracleType.NVarChar).Value = dwData["KADBZINSZS"].ToString(); 
          or1.Parameters.Add("KADBZINSBAS", OracleType.NVarChar).Value = dwData["KADBZINSBAS"].ToString(); 
          or1.Parameters.Add("KADBZINSPROZ", OracleType.NVarChar).Value = dwData["KADBZINSPROZ"].ToString(); 
          or1.Parameters.Add("KADBZINST", OracleType.NVarChar).Value = dwData["KADBZINST"].ToString(); 
          or1.Parameters.Add("KADBVWET1", OracleType.NVarChar).Value = dwData["KADBVWET1"].ToString(); 
          or1.Parameters.Add("KADBVWET2", OracleType.NVarChar).Value = dwData["KADBVWET2"].ToString(); 
          or1.Parameters.Add("KADBVWET3", OracleType.NVarChar).Value = dwData["KADBVWET3"].ToString(); 
          or1.Parameters.Add("KADBVWET4", OracleType.NVarChar).Value = dwData["KADBVWET4"].ToString(); 
          or1.Parameters.Add("KADBVWET5", OracleType.NVarChar).Value = dwData["KADBVWET5"].ToString(); 
          or1.Parameters.Add("KADBVWET6", OracleType.NVarChar).Value = dwData["KADBVWET6"].ToString(); 
          or1.Parameters.Add("KADBVWET7", OracleType.NVarChar).Value = dwData["KADBVWET7"].ToString(); 
          or1.Parameters.Add("KADBVWET8", OracleType.NVarChar).Value = dwData["KADBVWET8"].ToString(); 
          or1.Parameters.Add("KADBVWET9", OracleType.NVarChar).Value = dwData["KADBVWET9"].ToString(); 
          or1.Parameters.Add("KADBVWET10", OracleType.NVarChar).Value = dwData["KADBVWET10"].ToString(); 
          or1.Parameters.Add("KADBFILLER", OracleType.NVarChar).Value = dwData["KADBFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
